<?php
class comment_model extends my_model{
	function __construct(){
		parent::__construct();
		$this->_prefix = "com";
		$this->_column = array(
								'id'			=>	$this->_prefix."_id",
								'title'			=>	$this->_prefix."_title",
								'content'		=>	$this->_prefix."_content",
								'usr_ip'		=>	$this->_prefix."_usr_ip",
								'status'		=>	$this->_prefix."_status",
								'parent_id'		=>	$this->_prefix."_parent_id",
								'cr_date'		=>	$this->_prefix."_cr_date",
								'lu_uid'		=>	$this->_prefix."_lu_uid",
								'lu_date'		=>	$this->_prefix."_lu_date",
								'usr_id'		=>	$this->_prefix."_usr_id",
								'pos_id'		=>	$this->_prefix."_pos_id"


			);
		$this->_join_column = array(

								'username' => "usr_username",
								'firstname' => "usr_firstname"

			);

	}
	 function get($options = NULL){
    $this->db->join("ci_user","ci_user.usr_id = ci_comment.com_usr_id");
    $mainTable = parent::get($options);
    return $mainTable;
  }
}




?>